Long-Run Cash Rent Spreadsheet Tool
by Michael Langemeier
Updated October 2025
This spreadsheet uses enterprise budget information, projected yields, and projected prices to examine breakeven prices, earnings per acre, breakeven cash rents, and trends in working capital.
Farmers typically find that rental rates don’t adjust rapidly during a downturn and consequently they lose money on rented land. But most farmers don’t want to give up rented land even if it is not profitable because it is difficult to find another parcel to replace it. They continue to hold on to rented land waiting for better prices, lower costs, and/or higher yields. The fundamental question is how long can they delay the decision. In other words, when should they hold them and when should they fold them? This question has become even more relevant today, given the financial pressure currently faced by crop producers across the Corn Belt, including lower commodity prices, tighter margins, and higher interest rates. Read more on using the spreadsheet tool here!
TAGS:
TEAM LINKS:
RELATED RESOURCES
UPCOMING EVENTS
December 1 & 8, 2025
Join Purdue Extension for a two-part workshop designed to help you gain a clearer understanding of tax planning essentials. The first session on December 1 will focus on the fundamentals of farm taxes, with particular emphasis on strategies that can be used in a low net income year. The second session on December 8 will focus on key tax strategies and will allow plenty of time for questions. Registration cost is only $20.
Read MoreDecember 15, 2025
This program provides in-depth coverage of agricultural and farm tax issues. In addition to covering timely tax issues, we will cover disaster tax issues, depreciation and expensing farm assets, retirement planning for farms, and tax planning in low-income years. This year’s webinar will be co-taught by a team from Ohio State and Purdue Universities.
Read MoreJanuary 27 or 28, 2026
Farm Shield is more than a conference, it’s a commitment to helping agricultural families build resilience and plan for a secure future. Don’t miss this opportunity to protect your legacy!
Read More